{
 "metadata": {
  "name": "",
  "signature": "sha256:17d73e4b2e0d96fd7bf333f108730b198b307090771a4251d0e39eeeef4bf483"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import sys"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 1
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "from pandas import Series, DataFrame"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 3
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "sys.path.append('/Users/Pro/Ongoing/weibo')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 4
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import weiboPredict"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 5
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "from weiboPredict import framework as fw"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 6
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.loadData()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 7
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "ug = fw.weibo_train_data.groupby('uid')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 9
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "uavg=ug.sum()/ug.count()[['forward_count','comment_count','like_count']]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 29
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "uavg=uavg.applymap(lambda x:round(x))"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 34
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "pd.merge(fw.weibo_train_data,uavg,"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>forward_count</th>\n",
        "      <th>comment_count</th>\n",
        "      <th>like_count</th>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>uid</th>\n",
        "      <th></th>\n",
        "      <th></th>\n",
        "      <th></th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>000127c6126e2b0019f255ed21ac1cb7</th>\n",
        "      <td>  6.000000</td>\n",
        "      <td> 14.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0001565a5edece1669577e2ace9a6a3d</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.045455</td>\n",
        "      <td> 0.090909</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>00033a6513b86b2705de9ffa9d37ffb6</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.250000</td>\n",
        "      <td> 0.312500</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0004fe2742507420eaa73e119dc83ac5</th>\n",
        "      <td>  0.027778</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.027778</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>000baeff4f88606d4f71af40b8599018</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.333333</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>000c663a24a2f91f4ba156fcd4f8b9f2</th>\n",
        "      <td>  0.016667</td>\n",
        "      <td>  0.266667</td>\n",
        "      <td> 0.291667</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>000ce19d2fccb1f22421bec50bf25b08</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>000d7bf7406392b2212dfb4fe907d946</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0012edb614365800e901c7f2b47e9129</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>001349a053bdecf1a71960f29288ced1</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0015c42ec93854687a258a7f170c6acf</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0018981548499228eeb3d4fbaef98f73</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.400000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>00189988dcb049bfb451e8d496a24c99</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.400000</td>\n",
        "      <td> 0.600000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0018b27ecc1370e4208b6b2f175e6651</th>\n",
        "      <td>  0.163265</td>\n",
        "      <td>  0.142857</td>\n",
        "      <td> 0.142857</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>001d259734bccab73fdc373803c1fcd3</th>\n",
        "      <td>  2.291667</td>\n",
        "      <td>  1.562500</td>\n",
        "      <td> 0.958333</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>001d458a43e7fd1d9f8e2eba54d5d2fe</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.500000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>001e00fddab72bf7e6be3455e199904a</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.018182</td>\n",
        "      <td> 0.018182</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>001fe802d7b8a3f5782b25acf0410440</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>00203b1aa005f8e374c1e681f5c2ba20</th>\n",
        "      <td>  0.250000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>00212e7163d4aa64f2d7956a35027aa3</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>00218177a5d1ada9c56331c981a549c3</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.250000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>00218f81fb7713a915d74a1d44f95b0b</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  3.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0021b2d3daa5c7e08857af6c13995a9d</th>\n",
        "      <td>  9.000000</td>\n",
        "      <td>  1.666667</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>00235ea45eb587598e730a01e0c95435</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.333333</td>\n",
        "      <td> 0.333333</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0024afeb386597432b7fe0d0a4bd9520</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0025dbd9e5a7d29077c93110a2334915</th>\n",
        "      <td>  0.333333</td>\n",
        "      <td>  1.000000</td>\n",
        "      <td> 0.666667</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0025fdc5741eb5afeeda3c90b8b35450</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  1.500000</td>\n",
        "      <td> 1.500000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0026416dd4943c8b119896c1e824227b</th>\n",
        "      <td>  0.045455</td>\n",
        "      <td>  0.045455</td>\n",
        "      <td> 0.045455</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0026bf3bb797997289aa4bd80d2965f6</th>\n",
        "      <td>  0.500000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0029dfdfa232aba1d4ce3f492135561e</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffe42732a2e7e1d039358065c1ca0b0f</th>\n",
        "      <td>  1.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffe43709a23926d8c67f2fd2b6b47484</th>\n",
        "      <td>  1.052632</td>\n",
        "      <td>  0.289474</td>\n",
        "      <td> 0.184211</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffe48112944f8c6d663e5c3e7d75af6a</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffe56fb4917b43ab3264598abfeff9f7</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffe71963fb7fa7851ee9b4e2c2ce72df</th>\n",
        "      <td>  0.128205</td>\n",
        "      <td>  0.102564</td>\n",
        "      <td> 0.102564</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffe751a2fae65c20da06746d6ca27b91</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.500000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffe8cdf01ecb2f53994e9e9da3e67e2b</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.155556</td>\n",
        "      <td> 0.377778</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffe8dc72ef634638d7ddffb6dc79cb1b</th>\n",
        "      <td>  0.166667</td>\n",
        "      <td>  0.166667</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffeaea408edaab9fd486aac63658824c</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  1.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffebca57cf8bab67883d2db042b89fcf</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.333333</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffecf83a6a52ef9a8732c12b7292ef28</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffefb5e064e72ca10ab4372391c265ce</th>\n",
        "      <td>  0.733333</td>\n",
        "      <td>  0.833333</td>\n",
        "      <td> 0.153333</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffefd6add74a653d91f729e85154493a</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff02e56b2bdd9d8da2877b42cdf2a3e</th>\n",
        "      <td>  0.247619</td>\n",
        "      <td>  1.438095</td>\n",
        "      <td> 0.704762</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff092ad59869987f022e62337c5efe5</th>\n",
        "      <td>  0.666667</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.166667</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff25a31885431b3adf2540f066040d0</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff3b5b067b1e1671a8208f3c014430a</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff48bb93b55b8132df63dc6b3e6fc13</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff57978753d3b84e8427f1a9b0038fd</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff5fe2707a4209e4be3d03a024db2eb</th>\n",
        "      <td>  2.093750</td>\n",
        "      <td>  1.437500</td>\n",
        "      <td> 0.718750</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff67a9d6f8b2745a2cada662fc9c4a9</th>\n",
        "      <td>  0.888889</td>\n",
        "      <td>  0.888889</td>\n",
        "      <td> 3.222222</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff7d9e6a58934f7f40f23b67c4196b8</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fff835220e94f8cd86790c43fba63122</th>\n",
        "      <td> 10.750000</td>\n",
        "      <td>  0.625000</td>\n",
        "      <td> 0.125000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fffb8f592e72d9faa20ca65119c0acc1</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fffb96446162927dd6c69124f250bbf0</th>\n",
        "      <td>  0.040000</td>\n",
        "      <td>  0.520000</td>\n",
        "      <td> 0.560000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>fffcc9de3131383d2c7111e2e15b740d</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.000000</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffff3110aae05333d489d3707bee1d17</th>\n",
        "      <td>  0.008772</td>\n",
        "      <td>  0.087719</td>\n",
        "      <td> 0.070175</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffff38efb04819e645a0768568ec2346</th>\n",
        "      <td>  0.000000</td>\n",
        "      <td>  0.083333</td>\n",
        "      <td> 0.000000</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffff39bf301adf32d06aae9dc70892fa</th>\n",
        "      <td>  0.265306</td>\n",
        "      <td>  0.816327</td>\n",
        "      <td> 0.102041</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>ffff5e493015a9240bd4d29de15ef55b</th>\n",
        "      <td>  0.022222</td>\n",
        "      <td>  0.244444</td>\n",
        "      <td> 0.100000</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>45671 rows \u00d7 3 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 28,
       "text": [
        "                                  forward_count  comment_count  like_count\n",
        "uid                                                                       \n",
        "000127c6126e2b0019f255ed21ac1cb7       6.000000      14.000000    0.000000\n",
        "0001565a5edece1669577e2ace9a6a3d       0.000000       0.045455    0.090909\n",
        "00033a6513b86b2705de9ffa9d37ffb6       0.000000       0.250000    0.312500\n",
        "0004fe2742507420eaa73e119dc83ac5       0.027778       0.000000    0.027778\n",
        "000baeff4f88606d4f71af40b8599018       0.000000       0.000000    0.333333\n",
        "000c663a24a2f91f4ba156fcd4f8b9f2       0.016667       0.266667    0.291667\n",
        "000ce19d2fccb1f22421bec50bf25b08       0.000000       0.000000    0.000000\n",
        "000d7bf7406392b2212dfb4fe907d946       0.000000       0.000000    0.000000\n",
        "0012edb614365800e901c7f2b47e9129       0.000000       0.000000    0.000000\n",
        "001349a053bdecf1a71960f29288ced1       0.000000       0.000000    0.000000\n",
        "0015c42ec93854687a258a7f170c6acf       0.000000       0.000000    0.000000\n",
        "0018981548499228eeb3d4fbaef98f73       0.000000       0.400000    0.000000\n",
        "00189988dcb049bfb451e8d496a24c99       0.000000       0.400000    0.600000\n",
        "0018b27ecc1370e4208b6b2f175e6651       0.163265       0.142857    0.142857\n",
        "001d259734bccab73fdc373803c1fcd3       2.291667       1.562500    0.958333\n",
        "001d458a43e7fd1d9f8e2eba54d5d2fe       0.000000       0.500000    0.000000\n",
        "001e00fddab72bf7e6be3455e199904a       0.000000       0.018182    0.018182\n",
        "001fe802d7b8a3f5782b25acf0410440       0.000000       0.000000    0.000000\n",
        "00203b1aa005f8e374c1e681f5c2ba20       0.250000       0.000000    0.000000\n",
        "00212e7163d4aa64f2d7956a35027aa3       0.000000       0.000000    0.000000\n",
        "00218177a5d1ada9c56331c981a549c3       0.000000       0.000000    0.250000\n",
        "00218f81fb7713a915d74a1d44f95b0b       0.000000       3.000000    0.000000\n",
        "0021b2d3daa5c7e08857af6c13995a9d       9.000000       1.666667    0.000000\n",
        "00235ea45eb587598e730a01e0c95435       0.000000       0.333333    0.333333\n",
        "0024afeb386597432b7fe0d0a4bd9520       0.000000       0.000000    0.000000\n",
        "0025dbd9e5a7d29077c93110a2334915       0.333333       1.000000    0.666667\n",
        "0025fdc5741eb5afeeda3c90b8b35450       0.000000       1.500000    1.500000\n",
        "0026416dd4943c8b119896c1e824227b       0.045455       0.045455    0.045455\n",
        "0026bf3bb797997289aa4bd80d2965f6       0.500000       0.000000    0.000000\n",
        "0029dfdfa232aba1d4ce3f492135561e       0.000000       0.000000    0.000000\n",
        "...                                         ...            ...         ...\n",
        "ffe42732a2e7e1d039358065c1ca0b0f       1.000000       0.000000    0.000000\n",
        "ffe43709a23926d8c67f2fd2b6b47484       1.052632       0.289474    0.184211\n",
        "ffe48112944f8c6d663e5c3e7d75af6a       0.000000       0.000000    0.000000\n",
        "ffe56fb4917b43ab3264598abfeff9f7       0.000000       0.000000    0.000000\n",
        "ffe71963fb7fa7851ee9b4e2c2ce72df       0.128205       0.102564    0.102564\n",
        "ffe751a2fae65c20da06746d6ca27b91       0.000000       0.500000    0.000000\n",
        "ffe8cdf01ecb2f53994e9e9da3e67e2b       0.000000       0.155556    0.377778\n",
        "ffe8dc72ef634638d7ddffb6dc79cb1b       0.166667       0.166667    0.000000\n",
        "ffeaea408edaab9fd486aac63658824c       0.000000       1.000000    0.000000\n",
        "ffebca57cf8bab67883d2db042b89fcf       0.000000       0.000000    0.333333\n",
        "ffecf83a6a52ef9a8732c12b7292ef28       0.000000       0.000000    0.000000\n",
        "ffefb5e064e72ca10ab4372391c265ce       0.733333       0.833333    0.153333\n",
        "ffefd6add74a653d91f729e85154493a       0.000000       0.000000    0.000000\n",
        "fff02e56b2bdd9d8da2877b42cdf2a3e       0.247619       1.438095    0.704762\n",
        "fff092ad59869987f022e62337c5efe5       0.666667       0.000000    0.166667\n",
        "fff25a31885431b3adf2540f066040d0       0.000000       0.000000    0.000000\n",
        "fff3b5b067b1e1671a8208f3c014430a       0.000000       0.000000    0.000000\n",
        "fff48bb93b55b8132df63dc6b3e6fc13       0.000000       0.000000    0.000000\n",
        "fff57978753d3b84e8427f1a9b0038fd       0.000000       0.000000    0.000000\n",
        "fff5fe2707a4209e4be3d03a024db2eb       2.093750       1.437500    0.718750\n",
        "fff67a9d6f8b2745a2cada662fc9c4a9       0.888889       0.888889    3.222222\n",
        "fff7d9e6a58934f7f40f23b67c4196b8       0.000000       0.000000    0.000000\n",
        "fff835220e94f8cd86790c43fba63122      10.750000       0.625000    0.125000\n",
        "fffb8f592e72d9faa20ca65119c0acc1       0.000000       0.000000    0.000000\n",
        "fffb96446162927dd6c69124f250bbf0       0.040000       0.520000    0.560000\n",
        "fffcc9de3131383d2c7111e2e15b740d       0.000000       0.000000    0.000000\n",
        "ffff3110aae05333d489d3707bee1d17       0.008772       0.087719    0.070175\n",
        "ffff38efb04819e645a0768568ec2346       0.000000       0.083333    0.000000\n",
        "ffff39bf301adf32d06aae9dc70892fa       0.265306       0.816327    0.102041\n",
        "ffff5e493015a9240bd4d29de15ef55b       0.022222       0.244444    0.100000\n",
        "\n",
        "[45671 rows x 3 columns]"
       ]
      }
     ],
     "prompt_number": 28
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "train_data = fw.weibo_train_data[(fw.weibo_train_data.time>='2014-07-01') & (fw.weibo_train_data.time<='2014-11-30')]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 31
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "len(train_data)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 32,
       "text": [
        "1354048"
       ]
      }
     ],
     "prompt_number": 32
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "pd.merge(train_data[['uid']],uavg,how=\"inner\",left_on='uid',right_index=True)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>uid</th>\n",
        "      <th>forward_count</th>\n",
        "      <th>comment_count</th>\n",
        "      <th>like_count</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0      </th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1      </th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2      </th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3      </th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4      </th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5      </th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6      </th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7      </th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626721</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626722</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626723</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626724</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626725</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626726</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626727</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626728</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626729</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626730</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626731</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626732</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626733</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626734</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626735</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626736</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626737</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626738</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626739</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626740</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626741</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626742</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626682</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626683</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626684</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626685</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626686</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626687</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626688</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626689</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626690</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626691</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626692</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626693</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626694</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626695</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626696</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626697</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626698</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626699</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626700</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626701</th>\n",
        "      <td> fc8d3fc57c5f1789c62b5b0645e541c6</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626708</th>\n",
        "      <td> aa713c5644be151261aa4fe61c8c5e3b</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626709</th>\n",
        "      <td> aa713c5644be151261aa4fe61c8c5e3b</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626710</th>\n",
        "      <td> aa713c5644be151261aa4fe61c8c5e3b</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626711</th>\n",
        "      <td> 1af7df85a282df37a37feaaf623de27d</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626712</th>\n",
        "      <td> 1af7df85a282df37a37feaaf623de27d</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626713</th>\n",
        "      <td> 1af7df85a282df37a37feaaf623de27d</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626714</th>\n",
        "      <td> 1af7df85a282df37a37feaaf623de27d</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626715</th>\n",
        "      <td> 1af7df85a282df37a37feaaf623de27d</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626719</th>\n",
        "      <td> 91bf5ad032a873670bec62c459787230</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1626720</th>\n",
        "      <td> 91bf5ad032a873670bec62c459787230</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>1354048 rows \u00d7 4 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 39,
       "text": [
        "                                      uid  forward_count  comment_count  \\\n",
        "0        07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1        07fc721342df1a4c1992560b582992f8              0              1   \n",
        "2        07fc721342df1a4c1992560b582992f8              0              1   \n",
        "3        07fc721342df1a4c1992560b582992f8              0              1   \n",
        "4        07fc721342df1a4c1992560b582992f8              0              1   \n",
        "5        07fc721342df1a4c1992560b582992f8              0              1   \n",
        "6        07fc721342df1a4c1992560b582992f8              0              1   \n",
        "7        07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626721  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626722  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626723  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626724  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626725  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626726  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626727  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626728  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626729  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626730  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626731  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626732  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626733  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626734  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626735  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626736  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626737  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626738  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626739  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626740  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626741  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "1626742  07fc721342df1a4c1992560b582992f8              0              1   \n",
        "...                                   ...            ...            ...   \n",
        "1626682  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626683  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626684  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626685  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626686  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626687  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626688  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626689  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626690  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626691  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626692  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626693  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626694  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626695  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626696  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626697  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626698  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626699  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626700  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626701  fc8d3fc57c5f1789c62b5b0645e541c6              0              2   \n",
        "1626708  aa713c5644be151261aa4fe61c8c5e3b              0              0   \n",
        "1626709  aa713c5644be151261aa4fe61c8c5e3b              0              0   \n",
        "1626710  aa713c5644be151261aa4fe61c8c5e3b              0              0   \n",
        "1626711  1af7df85a282df37a37feaaf623de27d              0              0   \n",
        "1626712  1af7df85a282df37a37feaaf623de27d              0              0   \n",
        "1626713  1af7df85a282df37a37feaaf623de27d              0              0   \n",
        "1626714  1af7df85a282df37a37feaaf623de27d              0              0   \n",
        "1626715  1af7df85a282df37a37feaaf623de27d              0              0   \n",
        "1626719  91bf5ad032a873670bec62c459787230              0              0   \n",
        "1626720  91bf5ad032a873670bec62c459787230              0              0   \n",
        "\n",
        "         like_count  \n",
        "0                 0  \n",
        "1                 0  \n",
        "2                 0  \n",
        "3                 0  \n",
        "4                 0  \n",
        "5                 0  \n",
        "6                 0  \n",
        "7                 0  \n",
        "1626721           0  \n",
        "1626722           0  \n",
        "1626723           0  \n",
        "1626724           0  \n",
        "1626725           0  \n",
        "1626726           0  \n",
        "1626727           0  \n",
        "1626728           0  \n",
        "1626729           0  \n",
        "1626730           0  \n",
        "1626731           0  \n",
        "1626732           0  \n",
        "1626733           0  \n",
        "1626734           0  \n",
        "1626735           0  \n",
        "1626736           0  \n",
        "1626737           0  \n",
        "1626738           0  \n",
        "1626739           0  \n",
        "1626740           0  \n",
        "1626741           0  \n",
        "1626742           0  \n",
        "...             ...  \n",
        "1626682           0  \n",
        "1626683           0  \n",
        "1626684           0  \n",
        "1626685           0  \n",
        "1626686           0  \n",
        "1626687           0  \n",
        "1626688           0  \n",
        "1626689           0  \n",
        "1626690           0  \n",
        "1626691           0  \n",
        "1626692           0  \n",
        "1626693           0  \n",
        "1626694           0  \n",
        "1626695           0  \n",
        "1626696           0  \n",
        "1626697           0  \n",
        "1626698           0  \n",
        "1626699           0  \n",
        "1626700           0  \n",
        "1626701           0  \n",
        "1626708           0  \n",
        "1626709           0  \n",
        "1626710           0  \n",
        "1626711           0  \n",
        "1626712           0  \n",
        "1626713           0  \n",
        "1626714           0  \n",
        "1626715           0  \n",
        "1626719           0  \n",
        "1626720           0  \n",
        "\n",
        "[1354048 rows x 4 columns]"
       ]
      }
     ],
     "prompt_number": 39
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "reload(weiboPredict.framework)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 136,
       "text": [
        "<module 'weiboPredict.framework' from '/Users/Pro/Ongoing/weibo/weiboPredict/framework.pyc'>"
       ]
      }
     ],
     "prompt_number": 136
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.UAVG(data_time=['2014-07-01','2014-11-30'])"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>UAVG_forward_count_2014-07-01_2014-11-30</th>\n",
        "      <th>UAVG_comment_count_2014-07-01_2014-11-30</th>\n",
        "      <th>UAVG_like_count_2014-07-01_2014-11-30</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354018</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354019</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354020</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354021</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354022</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354023</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354024</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354025</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354026</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354027</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354028</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354029</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354030</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354031</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354032</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354033</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354034</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354035</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354036</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354037</th>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354038</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354039</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354040</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354041</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354042</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354043</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354044</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354045</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354046</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354047</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>1354048 rows \u00d7 3 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 95,
       "text": [
        "         UAVG_forward_count_2014-07-01_2014-11-30  \\\n",
        "0                                               0   \n",
        "1                                               0   \n",
        "2                                               0   \n",
        "3                                               0   \n",
        "4                                               0   \n",
        "5                                               0   \n",
        "6                                               0   \n",
        "7                                               0   \n",
        "8                                               0   \n",
        "9                                               0   \n",
        "10                                              0   \n",
        "11                                              0   \n",
        "12                                              0   \n",
        "13                                              0   \n",
        "14                                              0   \n",
        "15                                              0   \n",
        "16                                              0   \n",
        "17                                              0   \n",
        "18                                              0   \n",
        "19                                              0   \n",
        "20                                              0   \n",
        "21                                              0   \n",
        "22                                              0   \n",
        "23                                              0   \n",
        "24                                              0   \n",
        "25                                              0   \n",
        "26                                              0   \n",
        "27                                              0   \n",
        "28                                              0   \n",
        "29                                              0   \n",
        "...                                           ...   \n",
        "1354018                                         0   \n",
        "1354019                                         0   \n",
        "1354020                                         0   \n",
        "1354021                                         0   \n",
        "1354022                                         0   \n",
        "1354023                                         0   \n",
        "1354024                                         0   \n",
        "1354025                                         0   \n",
        "1354026                                         0   \n",
        "1354027                                         0   \n",
        "1354028                                         0   \n",
        "1354029                                         0   \n",
        "1354030                                         0   \n",
        "1354031                                         0   \n",
        "1354032                                         0   \n",
        "1354033                                         0   \n",
        "1354034                                         0   \n",
        "1354035                                         0   \n",
        "1354036                                         0   \n",
        "1354037                                         0   \n",
        "1354038                                         0   \n",
        "1354039                                         0   \n",
        "1354040                                         0   \n",
        "1354041                                         0   \n",
        "1354042                                         0   \n",
        "1354043                                         0   \n",
        "1354044                                         0   \n",
        "1354045                                         0   \n",
        "1354046                                         0   \n",
        "1354047                                         0   \n",
        "\n",
        "         UAVG_comment_count_2014-07-01_2014-11-30  \\\n",
        "0                                               1   \n",
        "1                                               1   \n",
        "2                                               1   \n",
        "3                                               1   \n",
        "4                                               1   \n",
        "5                                               1   \n",
        "6                                               1   \n",
        "7                                               1   \n",
        "8                                               1   \n",
        "9                                               1   \n",
        "10                                              1   \n",
        "11                                              1   \n",
        "12                                              1   \n",
        "13                                              1   \n",
        "14                                              1   \n",
        "15                                              1   \n",
        "16                                              1   \n",
        "17                                              1   \n",
        "18                                              1   \n",
        "19                                              1   \n",
        "20                                              1   \n",
        "21                                              1   \n",
        "22                                              1   \n",
        "23                                              1   \n",
        "24                                              1   \n",
        "25                                              1   \n",
        "26                                              1   \n",
        "27                                              1   \n",
        "28                                              1   \n",
        "29                                              1   \n",
        "...                                           ...   \n",
        "1354018                                         2   \n",
        "1354019                                         2   \n",
        "1354020                                         2   \n",
        "1354021                                         2   \n",
        "1354022                                         2   \n",
        "1354023                                         2   \n",
        "1354024                                         2   \n",
        "1354025                                         2   \n",
        "1354026                                         2   \n",
        "1354027                                         2   \n",
        "1354028                                         2   \n",
        "1354029                                         2   \n",
        "1354030                                         2   \n",
        "1354031                                         2   \n",
        "1354032                                         2   \n",
        "1354033                                         2   \n",
        "1354034                                         2   \n",
        "1354035                                         2   \n",
        "1354036                                         2   \n",
        "1354037                                         2   \n",
        "1354038                                         0   \n",
        "1354039                                         0   \n",
        "1354040                                         0   \n",
        "1354041                                         0   \n",
        "1354042                                         0   \n",
        "1354043                                         0   \n",
        "1354044                                         0   \n",
        "1354045                                         0   \n",
        "1354046                                         0   \n",
        "1354047                                         0   \n",
        "\n",
        "         UAVG_like_count_2014-07-01_2014-11-30  \n",
        "0                                            0  \n",
        "1                                            0  \n",
        "2                                            0  \n",
        "3                                            0  \n",
        "4                                            0  \n",
        "5                                            0  \n",
        "6                                            0  \n",
        "7                                            0  \n",
        "8                                            0  \n",
        "9                                            0  \n",
        "10                                           0  \n",
        "11                                           0  \n",
        "12                                           0  \n",
        "13                                           0  \n",
        "14                                           0  \n",
        "15                                           0  \n",
        "16                                           0  \n",
        "17                                           0  \n",
        "18                                           0  \n",
        "19                                           0  \n",
        "20                                           0  \n",
        "21                                           0  \n",
        "22                                           0  \n",
        "23                                           0  \n",
        "24                                           0  \n",
        "25                                           0  \n",
        "26                                           0  \n",
        "27                                           0  \n",
        "28                                           0  \n",
        "29                                           0  \n",
        "...                                        ...  \n",
        "1354018                                      0  \n",
        "1354019                                      0  \n",
        "1354020                                      0  \n",
        "1354021                                      0  \n",
        "1354022                                      0  \n",
        "1354023                                      0  \n",
        "1354024                                      0  \n",
        "1354025                                      0  \n",
        "1354026                                      0  \n",
        "1354027                                      0  \n",
        "1354028                                      0  \n",
        "1354029                                      0  \n",
        "1354030                                      0  \n",
        "1354031                                      0  \n",
        "1354032                                      0  \n",
        "1354033                                      0  \n",
        "1354034                                      0  \n",
        "1354035                                      0  \n",
        "1354036                                      0  \n",
        "1354037                                      0  \n",
        "1354038                                      0  \n",
        "1354039                                      0  \n",
        "1354040                                      0  \n",
        "1354041                                      0  \n",
        "1354042                                      0  \n",
        "1354043                                      0  \n",
        "1354044                                      0  \n",
        "1354045                                      0  \n",
        "1354046                                      0  \n",
        "1354047                                      0  \n",
        "\n",
        "[1354048 rows x 3 columns]"
       ]
      }
     ],
     "prompt_number": 95
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.features_log"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>feature_name</th>\n",
        "      <th>feature_type</th>\n",
        "      <th>data_time</th>\n",
        "      <th>parameters</th>\n",
        "      <th>category</th>\n",
        "      <th>feature_address</th>\n",
        "      <th>description</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td>  BOW</td>\n",
        "      <td> [2014-07-01, 2014-11-30]</td>\n",
        "      <td> {u'max_features': 100, u'vec_time': [u'2014-07...</td>\n",
        "      <td> I</td>\n",
        "      <td> ../features/BOW_2014-07-01_2014-11-30_2014-07-...</td>\n",
        "      <td> Bag of Words in word count from 2014-07-01 to ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> BOW_2014-12-01_2014-12-31_2014-07-01_2014-11-3...</td>\n",
        "      <td>  BOW</td>\n",
        "      <td> [2014-12-01, 2014-12-31]</td>\n",
        "      <td> {u'max_features': 100, u'vec_time': [u'2014-07...</td>\n",
        "      <td> I</td>\n",
        "      <td> ../features/BOW_2014-12-01_2014-12-31_2014-07-...</td>\n",
        "      <td> Bag of Words in word count from 2014-12-01 to ...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>                        UAVG_2014-07-01_2014-11-30</td>\n",
        "      <td> UAVG</td>\n",
        "      <td> [2014-07-01, 2014-11-30]</td>\n",
        "      <td>                                                {}</td>\n",
        "      <td> U</td>\n",
        "      <td>    ../features/UAVG_2014-07-01_2014-11-30.feature</td>\n",
        "      <td> User's average forward/comment/like count duri...</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 64,
       "text": [
        "                                        feature_name feature_type  \\\n",
        "0  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...          BOW   \n",
        "1  BOW_2014-12-01_2014-12-31_2014-07-01_2014-11-3...          BOW   \n",
        "2                         UAVG_2014-07-01_2014-11-30         UAVG   \n",
        "\n",
        "                  data_time  \\\n",
        "0  [2014-07-01, 2014-11-30]   \n",
        "1  [2014-12-01, 2014-12-31]   \n",
        "2  [2014-07-01, 2014-11-30]   \n",
        "\n",
        "                                          parameters category  \\\n",
        "0  {u'max_features': 100, u'vec_time': [u'2014-07...        I   \n",
        "1  {u'max_features': 100, u'vec_time': [u'2014-07...        I   \n",
        "2                                                 {}        U   \n",
        "\n",
        "                                     feature_address  \\\n",
        "0  ../features/BOW_2014-07-01_2014-11-30_2014-07-...   \n",
        "1  ../features/BOW_2014-12-01_2014-12-31_2014-07-...   \n",
        "2     ../features/UAVG_2014-07-01_2014-11-30.feature   \n",
        "\n",
        "                                         description  \n",
        "0  Bag of Words in word count from 2014-07-01 to ...  \n",
        "1  Bag of Words in word count from 2014-12-01 to ...  \n",
        "2  User's average forward/comment/like count duri...  "
       ]
      }
     ],
     "prompt_number": 64
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "features = [fw.features_log.ix[0].feature_name,fw.features_log.ix[2].feature_name]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 50
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "features"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 51,
       "text": [
        "['BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-30_100',\n",
        " 'UAVG_2014-07-01_2014-11-30']"
       ]
      }
     ],
     "prompt_number": 51
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.train(features,\"LR\",\"forward_count\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "loading features...\n",
        "loading label..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "training model..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "writing log..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "saving model..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "=====Results=====\n",
        "Coefficients: \n",
        "[ 0.77696742  0.31003855  0.01815934 -0.90710798  0.25787538 -0.22676169\n",
        " -0.18152191 -0.15730196 -0.20012968 -0.03140865  0.28672256 -0.31689996\n",
        " -0.4997124  -0.20996112 -0.62581598  0.16352301  0.65132241 -0.15948797\n",
        "  0.87829288 -0.30473765  1.10494402 -0.22368999  0.41003675 -0.10146614\n",
        "  0.03119318 -0.10351003  0.12428938 -0.39693858 -0.19336373  0.83622084\n",
        "  0.76828561  0.1757144   0.4207355  -0.03495495  0.86950488 -0.5701197\n",
        " -0.74062164  0.18324087  0.1095483   0.47009843 -0.0110887   0.19648227\n",
        " -0.37485972  0.35425777 -0.32367002 -0.16553089  0.47000528 -0.07090424\n",
        " -0.06488539 -0.06633056 -0.03595244 -0.32384939  0.44557561  0.13473144\n",
        " -0.17347427  0.02252841  0.37681374  0.23761744 -0.64906475 -0.35340188\n",
        "  0.13793671 -0.70729072  0.62678649 -0.50856049 -0.65581526 -0.06228234\n",
        "  0.21869849  0.8679616  -0.23351069 -0.01929177  0.82144422  0.69363745\n",
        "  0.08142406  1.20394771  0.94771709  0.01505972 -0.17809899  0.4615521\n",
        "  0.30006804 -0.29573137 -0.08136482 -0.05383966 -0.0981326   0.34021898\n",
        "  0.60943799 -0.211932   -0.19883527  0.16166059 -0.09554125 -0.20312636\n",
        "  0.41454238  0.50175191 -0.242965   -0.13131607  0.29428139 -0.19062702\n",
        "  0.34939215 -0.40190893 -0.38092316 -0.47784521  0.80386833 -0.69509905\n",
        "  0.42013294]\n",
        "Residual sum of squares: 9482.14\n",
        "Variance score: 0.02\n",
        "Train time:  8.57467794418 seconds.\n"
       ]
      },
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 131,
       "text": [
        "LinearRegression(copy_X=True, fit_intercept=True, normalize=False)"
       ]
      }
     ],
     "prompt_number": 131
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.train(features,\"LR\",\"comment_count\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "loading features...\n",
        "loading label..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "training model..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "writing log..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "saving model..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "=====Results=====\n",
        "Coefficients: \n",
        "[-0.12493901  0.00545203  0.02683198 -0.46168341  0.02200035  0.05888615\n",
        " -0.05199929  0.05105188 -0.07467141  0.08541243  0.01318776 -0.08988392\n",
        " -0.43552544 -0.10593432 -0.00930813  0.04691829  0.11999831 -0.22659764\n",
        "  0.32981363 -0.04919786  0.39022742  0.1462135   0.09593209 -0.06570243\n",
        "  0.03089602  0.26325653 -0.064553   -0.04736931  0.00336995  0.11735226\n",
        "  0.14143917  0.12584862  0.13122791 -0.04559111  0.09005373 -0.16453637\n",
        " -0.07592615  0.03485457  0.20996221  0.09718641  0.07816354 -0.00211218\n",
        " -0.00980061  0.13451504 -0.06095583 -0.07341768  0.29008079  0.22031922\n",
        " -0.02562766  0.02619315  0.02426546  0.00982284  0.07015969 -0.02211224\n",
        " -0.01953879 -0.06941677  0.17393818 -0.14477476 -0.0407412  -0.09930308\n",
        " -0.0129143  -0.0896798   0.07201253 -0.32487748 -0.20003937 -0.08553461\n",
        "  0.45623631  0.01581478 -0.01498668  0.09161323  0.35082484  0.06020918\n",
        "  0.06840829  0.46434568  0.21213105  0.05587582 -0.03263554 -0.16286258\n",
        "  0.35440364 -0.10582049 -0.06788858 -0.07717545 -0.02424243  0.14069884\n",
        "  0.00197846 -0.13652306 -0.00988293  0.07442454 -0.01555863 -0.12726675\n",
        "  0.01245841  0.12795382 -0.13032231 -0.16297698  0.21018871 -0.07310845\n",
        " -0.00347798 -0.12857541 -0.08247006 -0.16962547 -0.0862307   0.34858038\n",
        "  0.34021568]\n",
        "Residual sum of squares: 1355.89\n",
        "Variance score: 0.04\n",
        "Train time:  8.9391810894 seconds.\n"
       ]
      },
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 132,
       "text": [
        "LinearRegression(copy_X=True, fit_intercept=True, normalize=False)"
       ]
      }
     ],
     "prompt_number": 132
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.train(features,\"LR\",\"like_count\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "loading features...\n",
        "loading label..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "training model..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "writing log..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "saving model..."
       ]
      },
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\n",
        "=====Results=====\n",
        "Coefficients: \n",
        "[-0.28279062  0.0764333  -0.0235155  -0.09650648  0.08410196  0.02065317\n",
        " -0.13336277 -0.0033557  -0.04431459  0.05705168 -0.06729547 -0.06538247\n",
        " -0.11773367  0.03670991  0.1973834   0.05103404  0.06495829 -0.0338569\n",
        "  0.09183211 -0.07099128  0.00822969 -0.03360387  0.10331267 -0.07000182\n",
        "  0.07366672  0.10341795  0.07163288 -0.0210104  -0.03991606  0.0756218\n",
        "  0.04721421  0.15309784 -0.13973687  0.05628857  0.22646374  0.00838617\n",
        " -0.0847371   0.01713292 -0.00126142  0.10285077  0.03459077  0.01889799\n",
        "  0.02208647  0.02397577 -0.04610276 -0.02009213 -0.04578994  0.05311184\n",
        "  0.01888166 -0.02094016 -0.06954839 -0.05587628  0.178282   -0.2333347\n",
        "  0.10512268 -0.05394679  0.13916604 -0.01470867 -0.11662859  0.11314037\n",
        "  0.15146636 -0.06172331  0.03973285 -0.25936866 -0.05311125  0.03729523\n",
        "  0.03956734 -0.07981893  0.02857411 -0.04690978  0.00884846 -0.01549594\n",
        " -0.01912019  0.13449522  0.02747998 -0.00553156  0.02627139  0.02124568\n",
        " -0.0218872   0.04413982 -0.04497585  0.05011019  0.01433064  0.00688736\n",
        "  0.21026496 -0.07278852 -0.04370925 -0.01925491 -0.04992334 -0.02441151\n",
        "  0.08016846  0.0241778  -0.1806358  -0.12054128  0.20789656  0.03148044\n",
        " -0.01174742  0.01704505 -0.07130907 -0.02944422 -0.00129861 -0.07760708\n",
        "  0.98787707]\n",
        "Residual sum of squares: 290.27\n",
        "Variance score: 0.45\n",
        "Train time:  8.74082112312 seconds.\n"
       ]
      },
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 133,
       "text": [
        "LinearRegression(copy_X=True, fit_intercept=True, normalize=False)"
       ]
      }
     ],
     "prompt_number": 133
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "list(train_features.values.shape)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 109,
       "text": [
        "[1354048, 103]"
       ]
      }
     ],
     "prompt_number": 109
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "a = DataFrame([[1,2,3],[4,5,6]])"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 65
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "train_features"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>BOW_1</th>\n",
        "      <th>BOW_2</th>\n",
        "      <th>BOW_3</th>\n",
        "      <th>BOW_4</th>\n",
        "      <th>BOW_5</th>\n",
        "      <th>BOW_6</th>\n",
        "      <th>BOW_7</th>\n",
        "      <th>BOW_8</th>\n",
        "      <th>BOW_9</th>\n",
        "      <th>BOW_10</th>\n",
        "      <th>...</th>\n",
        "      <th>BOW_94</th>\n",
        "      <th>BOW_95</th>\n",
        "      <th>BOW_96</th>\n",
        "      <th>BOW_97</th>\n",
        "      <th>BOW_98</th>\n",
        "      <th>BOW_99</th>\n",
        "      <th>BOW_100</th>\n",
        "      <th>UAVG_forward_count_2014-07-01_2014-11-30</th>\n",
        "      <th>UAVG_comment_count_2014-07-01_2014-11-30</th>\n",
        "      <th>UAVG_like_count_2014-07-01_2014-11-30</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 3</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 3</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7      </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8      </th>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9      </th>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10     </th>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11     </th>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12     </th>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29     </th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354018</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354019</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354020</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354021</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354022</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354023</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354024</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354025</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354026</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354027</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354028</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354029</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354030</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354031</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354032</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354033</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354034</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354035</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 3</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354036</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354037</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354038</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354039</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354040</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354041</th>\n",
        "      <td> 2</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354042</th>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 2</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354043</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354044</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354045</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354046</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1354047</th>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td>...</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>1354048 rows \u00d7 103 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 118,
       "text": [
        "         BOW_1  BOW_2  BOW_3  BOW_4  BOW_5  BOW_6  BOW_7  BOW_8  BOW_9  \\\n",
        "0            0      0      0      0      3      1      0      0      0   \n",
        "1            0      0      0      0      0      0      0      0      0   \n",
        "2            0      0      0      0      0      0      0      0      0   \n",
        "3            0      0      0      0      0      0      0      0      0   \n",
        "4            0      0      0      0      0      0      0      0      0   \n",
        "5            0      0      0      0      0      0      0      0      0   \n",
        "6            0      0      0      0      0      1      0      0      0   \n",
        "7            0      0      0      0      0      0      0      0      0   \n",
        "8            1      1      1      1      0      0      0      0      0   \n",
        "9            1      1      1      1      0      0      0      0      0   \n",
        "10           1      1      1      1      0      0      0      0      0   \n",
        "11           1      1      1      1      0      0      0      0      0   \n",
        "12           1      1      1      1      0      0      0      0      0   \n",
        "13           0      0      0      0      1      0      0      0      0   \n",
        "14           0      0      0      0      0      0      0      0      0   \n",
        "15           0      0      0      0      0      0      0      1      0   \n",
        "16           0      0      0      0      0      0      0      0      0   \n",
        "17           0      0      0      0      0      1      0      0      0   \n",
        "18           0      0      0      0      0      0      0      0      0   \n",
        "19           0      0      0      0      0      0      0      0      0   \n",
        "20           0      0      0      0      0      0      0      0      0   \n",
        "21           0      0      0      0      0      0      0      0      0   \n",
        "22           0      0      0      0      1      0      0      0      0   \n",
        "23           0      0      0      0      0      0      0      0      0   \n",
        "24           0      0      0      0      0      0      0      0      0   \n",
        "25           0      0      0      0      0      0      0      0      0   \n",
        "26           0      0      0      0      0      0      0      0      0   \n",
        "27           0      0      0      0      0      0      0      0      0   \n",
        "28           0      0      0      0      0      0      0      0      0   \n",
        "29           0      0      0      0      0      0      0      0      0   \n",
        "...        ...    ...    ...    ...    ...    ...    ...    ...    ...   \n",
        "1354018      0      0      0      0      0      0      0      0      0   \n",
        "1354019      0      0      0      0      1      0      0      0      0   \n",
        "1354020      0      0      0      0      0      0      0      0      0   \n",
        "1354021      0      0      0      0      0      0      0      0      0   \n",
        "1354022      0      0      0      0      0      0      0      0      0   \n",
        "1354023      0      0      0      0      0      0      0      0      0   \n",
        "1354024      0      0      0      0      0      0      0      0      0   \n",
        "1354025      0      0      0      0      0      1      0      0      0   \n",
        "1354026      0      0      0      0      1      0      0      0      0   \n",
        "1354027      0      0      0      0      0      0      0      1      0   \n",
        "1354028      0      0      0      0      0      1      0      0      0   \n",
        "1354029      0      0      0      0      1      0      0      0      0   \n",
        "1354030      0      0      0      0      1      1      1      1      0   \n",
        "1354031      0      0      0      0      0      0      0      0      0   \n",
        "1354032      0      0      0      0      0      0      1      0      0   \n",
        "1354033      0      0      0      0      0      0      0      0      0   \n",
        "1354034      0      0      0      0      0      0      0      0      0   \n",
        "1354035      0      0      0      0      3      0      0      0      0   \n",
        "1354036      0      0      0      0      0      0      0      0      0   \n",
        "1354037      0      0      0      0      0      0      0      0      0   \n",
        "1354038      0      0      0      0      0      0      0      0      0   \n",
        "1354039      0      0      0      0      0      0      0      0      0   \n",
        "1354040      0      0      0      0      1      0      0      0      0   \n",
        "1354041      2      1      0      0      1      1      0      0      0   \n",
        "1354042      1      1      0      0      1      0      1      0      0   \n",
        "1354043      0      0      0      0      0      0      0      0      0   \n",
        "1354044      0      0      0      0      1      0      0      0      0   \n",
        "1354045      0      0      0      0      0      0      0      0      0   \n",
        "1354046      0      0      0      0      0      1      0      0      0   \n",
        "1354047      0      0      0      0      0      0      0      0      0   \n",
        "\n",
        "         BOW_10   ...    BOW_94  BOW_95  BOW_96  BOW_97  BOW_98  BOW_99  \\\n",
        "0             1   ...         0       0       0       0       0       0   \n",
        "1             0   ...         0       0       0       0       0       0   \n",
        "2             0   ...         0       0       0       0       0       0   \n",
        "3             0   ...         0       0       0       0       0       0   \n",
        "4             0   ...         0       0       0       0       0       0   \n",
        "5             0   ...         0       0       0       0       0       0   \n",
        "6             0   ...         0       0       0       0       0       0   \n",
        "7             0   ...         0       0       0       0       0       0   \n",
        "8             0   ...         0       0       0       0       0       0   \n",
        "9             0   ...         0       0       0       0       0       0   \n",
        "10            0   ...         0       0       0       0       0       0   \n",
        "11            0   ...         0       0       0       0       0       0   \n",
        "12            0   ...         0       0       0       0       1       0   \n",
        "13            0   ...         0       0       0       0       0       1   \n",
        "14            0   ...         2       0       0       0       0       0   \n",
        "15            0   ...         0       0       0       0       0       0   \n",
        "16            1   ...         0       0       0       0       0       0   \n",
        "17            0   ...         0       0       0       0       0       0   \n",
        "18            0   ...         0       0       0       0       0       0   \n",
        "19            0   ...         0       0       0       0       0       0   \n",
        "20            0   ...         0       0       0       0       0       0   \n",
        "21            0   ...         0       0       0       0       0       0   \n",
        "22            0   ...         2       0       1       0       1       0   \n",
        "23            0   ...         0       0       0       0       0       0   \n",
        "24            0   ...         0       0       0       0       0       0   \n",
        "25            0   ...         0       0       0       0       0       0   \n",
        "26            0   ...         0       0       0       0       0       0   \n",
        "27            0   ...         0       0       0       0       0       0   \n",
        "28            0   ...         0       0       0       0       0       0   \n",
        "29            0   ...         0       0       0       0       0       0   \n",
        "...         ...   ...       ...     ...     ...     ...     ...     ...   \n",
        "1354018       0   ...         0       0       0       0       0       0   \n",
        "1354019       0   ...         0       0       0       0       0       0   \n",
        "1354020       0   ...         0       0       0       0       0       0   \n",
        "1354021       0   ...         0       0       0       0       0       0   \n",
        "1354022       0   ...         0       0       0       0       0       0   \n",
        "1354023       0   ...         0       0       0       0       0       0   \n",
        "1354024       0   ...         0       0       0       0       0       0   \n",
        "1354025       1   ...         0       0       0       0       0       0   \n",
        "1354026       1   ...         0       0       0       0       0       0   \n",
        "1354027       0   ...         0       0       0       0       0       1   \n",
        "1354028       0   ...         0       0       0       0       0       0   \n",
        "1354029       0   ...         0       0       0       1       1       0   \n",
        "1354030       0   ...         0       0       0       0       0       0   \n",
        "1354031       0   ...         0       0       0       0       0       0   \n",
        "1354032       0   ...         0       0       0       0       0       0   \n",
        "1354033       0   ...         0       0       0       0       0       0   \n",
        "1354034       0   ...         0       0       1       0       0       0   \n",
        "1354035       0   ...         0       0       0       1       0       0   \n",
        "1354036       0   ...         0       0       0       0       0       0   \n",
        "1354037       0   ...         0       0       0       0       0       0   \n",
        "1354038       0   ...         0       0       0       0       0       0   \n",
        "1354039       0   ...         0       0       0       0       0       0   \n",
        "1354040       0   ...         0       0       0       0       0       1   \n",
        "1354041       0   ...         0       0       0       0       0       0   \n",
        "1354042       0   ...         2       0       0       0       0       0   \n",
        "1354043       0   ...         0       0       0       0       0       0   \n",
        "1354044       1   ...         0       0       0       0       0       0   \n",
        "1354045       0   ...         0       0       0       0       0       0   \n",
        "1354046       0   ...         0       0       0       0       0       0   \n",
        "1354047       1   ...         0       0       0       0       0       0   \n",
        "\n",
        "         BOW_100  UAVG_forward_count_2014-07-01_2014-11-30  \\\n",
        "0              0                                         0   \n",
        "1              3                                         0   \n",
        "2              0                                         0   \n",
        "3              0                                         0   \n",
        "4              0                                         0   \n",
        "5              0                                         0   \n",
        "6              0                                         0   \n",
        "7              0                                         0   \n",
        "8              0                                         0   \n",
        "9              0                                         0   \n",
        "10             0                                         0   \n",
        "11             0                                         0   \n",
        "12             0                                         0   \n",
        "13             0                                         0   \n",
        "14             0                                         0   \n",
        "15             0                                         0   \n",
        "16             0                                         0   \n",
        "17             0                                         0   \n",
        "18             0                                         0   \n",
        "19             0                                         0   \n",
        "20             0                                         0   \n",
        "21             0                                         0   \n",
        "22             0                                         0   \n",
        "23             0                                         0   \n",
        "24             0                                         0   \n",
        "25             0                                         0   \n",
        "26             0                                         0   \n",
        "27             0                                         0   \n",
        "28             0                                         0   \n",
        "29             0                                         0   \n",
        "...          ...                                       ...   \n",
        "1354018        0                                         0   \n",
        "1354019        0                                         0   \n",
        "1354020        0                                         0   \n",
        "1354021        0                                         0   \n",
        "1354022        0                                         0   \n",
        "1354023        0                                         0   \n",
        "1354024        0                                         0   \n",
        "1354025        1                                         0   \n",
        "1354026        0                                         0   \n",
        "1354027        0                                         0   \n",
        "1354028        0                                         0   \n",
        "1354029        0                                         0   \n",
        "1354030        0                                         0   \n",
        "1354031        0                                         0   \n",
        "1354032        1                                         0   \n",
        "1354033        0                                         0   \n",
        "1354034        0                                         0   \n",
        "1354035        0                                         0   \n",
        "1354036        0                                         0   \n",
        "1354037        0                                         0   \n",
        "1354038        0                                         0   \n",
        "1354039        0                                         0   \n",
        "1354040        0                                         0   \n",
        "1354041        1                                         0   \n",
        "1354042        0                                         0   \n",
        "1354043        0                                         0   \n",
        "1354044        0                                         0   \n",
        "1354045        0                                         0   \n",
        "1354046        0                                         0   \n",
        "1354047        0                                         0   \n",
        "\n",
        "         UAVG_comment_count_2014-07-01_2014-11-30  \\\n",
        "0                                               1   \n",
        "1                                               1   \n",
        "2                                               1   \n",
        "3                                               1   \n",
        "4                                               1   \n",
        "5                                               1   \n",
        "6                                               1   \n",
        "7                                               1   \n",
        "8                                               1   \n",
        "9                                               1   \n",
        "10                                              1   \n",
        "11                                              1   \n",
        "12                                              1   \n",
        "13                                              1   \n",
        "14                                              1   \n",
        "15                                              1   \n",
        "16                                              1   \n",
        "17                                              1   \n",
        "18                                              1   \n",
        "19                                              1   \n",
        "20                                              1   \n",
        "21                                              1   \n",
        "22                                              1   \n",
        "23                                              1   \n",
        "24                                              1   \n",
        "25                                              1   \n",
        "26                                              1   \n",
        "27                                              1   \n",
        "28                                              1   \n",
        "29                                              1   \n",
        "...                                           ...   \n",
        "1354018                                         2   \n",
        "1354019                                         2   \n",
        "1354020                                         2   \n",
        "1354021                                         2   \n",
        "1354022                                         2   \n",
        "1354023                                         2   \n",
        "1354024                                         2   \n",
        "1354025                                         2   \n",
        "1354026                                         2   \n",
        "1354027                                         2   \n",
        "1354028                                         2   \n",
        "1354029                                         2   \n",
        "1354030                                         2   \n",
        "1354031                                         2   \n",
        "1354032                                         2   \n",
        "1354033                                         2   \n",
        "1354034                                         2   \n",
        "1354035                                         2   \n",
        "1354036                                         2   \n",
        "1354037                                         2   \n",
        "1354038                                         0   \n",
        "1354039                                         0   \n",
        "1354040                                         0   \n",
        "1354041                                         0   \n",
        "1354042                                         0   \n",
        "1354043                                         0   \n",
        "1354044                                         0   \n",
        "1354045                                         0   \n",
        "1354046                                         0   \n",
        "1354047                                         0   \n",
        "\n",
        "         UAVG_like_count_2014-07-01_2014-11-30  \n",
        "0                                            0  \n",
        "1                                            0  \n",
        "2                                            0  \n",
        "3                                            0  \n",
        "4                                            0  \n",
        "5                                            0  \n",
        "6                                            0  \n",
        "7                                            0  \n",
        "8                                            0  \n",
        "9                                            0  \n",
        "10                                           0  \n",
        "11                                           0  \n",
        "12                                           0  \n",
        "13                                           0  \n",
        "14                                           0  \n",
        "15                                           0  \n",
        "16                                           0  \n",
        "17                                           0  \n",
        "18                                           0  \n",
        "19                                           0  \n",
        "20                                           0  \n",
        "21                                           0  \n",
        "22                                           0  \n",
        "23                                           0  \n",
        "24                                           0  \n",
        "25                                           0  \n",
        "26                                           0  \n",
        "27                                           0  \n",
        "28                                           0  \n",
        "29                                           0  \n",
        "...                                        ...  \n",
        "1354018                                      0  \n",
        "1354019                                      0  \n",
        "1354020                                      0  \n",
        "1354021                                      0  \n",
        "1354022                                      0  \n",
        "1354023                                      0  \n",
        "1354024                                      0  \n",
        "1354025                                      0  \n",
        "1354026                                      0  \n",
        "1354027                                      0  \n",
        "1354028                                      0  \n",
        "1354029                                      0  \n",
        "1354030                                      0  \n",
        "1354031                                      0  \n",
        "1354032                                      0  \n",
        "1354033                                      0  \n",
        "1354034                                      0  \n",
        "1354035                                      0  \n",
        "1354036                                      0  \n",
        "1354037                                      0  \n",
        "1354038                                      0  \n",
        "1354039                                      0  \n",
        "1354040                                      0  \n",
        "1354041                                      0  \n",
        "1354042                                      0  \n",
        "1354043                                      0  \n",
        "1354044                                      0  \n",
        "1354045                                      0  \n",
        "1354046                                      0  \n",
        "1354047                                      0  \n",
        "\n",
        "[1354048 rows x 103 columns]"
       ]
      }
     ],
     "prompt_number": 118
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "a.loc[a[a[1]==4].index.values[0]]=[1,2,3]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 91
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.loadData()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 137
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.features_log"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>feature_name</th>\n",
        "      <th>feature_type</th>\n",
        "      <th>data_time</th>\n",
        "      <th>parameters</th>\n",
        "      <th>category</th>\n",
        "      <th>feature_address</th>\n",
        "      <th>description</th>\n",
        "      <th>feature_shape</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td>  BOW</td>\n",
        "      <td> [\"2014-07-01\", \"2014-11-30\"]</td>\n",
        "      <td> {\"max_features\": 100, \"vec_time\": [\"2014-07-01...</td>\n",
        "      <td> I</td>\n",
        "      <td> ../features/BOW_2014-07-01_2014-11-30_2014-07-...</td>\n",
        "      <td> Bag of Words in word count from 2014-07-01 to ...</td>\n",
        "      <td> [1354048, 100]</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> BOW_2014-12-01_2014-12-31_2014-07-01_2014-11-3...</td>\n",
        "      <td>  BOW</td>\n",
        "      <td> [\"2014-12-01\", \"2014-12-31\"]</td>\n",
        "      <td> {\"max_features\": 100, \"vec_time\": [\"2014-07-01...</td>\n",
        "      <td> I</td>\n",
        "      <td> ../features/BOW_2014-12-01_2014-12-31_2014-07-...</td>\n",
        "      <td> Bag of Words in word count from 2014-12-01 to ...</td>\n",
        "      <td>  [272702, 100]</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>                        UAVG_2014-07-01_2014-11-30</td>\n",
        "      <td> UAVG</td>\n",
        "      <td> [\"2014-07-01\", \"2014-11-30\"]</td>\n",
        "      <td>                                                {}</td>\n",
        "      <td> U</td>\n",
        "      <td>    ../features/UAVG_2014-07-01_2014-11-30.feature</td>\n",
        "      <td> User's average forward/comment/like count duri...</td>\n",
        "      <td>   [1354048, 3]</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>                        UAVG_2014-12-01_2014-12-31</td>\n",
        "      <td> UAVG</td>\n",
        "      <td> [\"2014-12-01\", \"2014-12-31\"]</td>\n",
        "      <td>                                                {}</td>\n",
        "      <td> U</td>\n",
        "      <td>    ../features/UAVG_2014-12-01_2014-12-31.feature</td>\n",
        "      <td> User's average forward/comment/like count duri...</td>\n",
        "      <td>    [272702, 3]</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 143,
       "text": [
        "                                        feature_name feature_type  \\\n",
        "0  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...          BOW   \n",
        "1  BOW_2014-12-01_2014-12-31_2014-07-01_2014-11-3...          BOW   \n",
        "2                         UAVG_2014-07-01_2014-11-30         UAVG   \n",
        "3                         UAVG_2014-12-01_2014-12-31         UAVG   \n",
        "\n",
        "                      data_time  \\\n",
        "0  [\"2014-07-01\", \"2014-11-30\"]   \n",
        "1  [\"2014-12-01\", \"2014-12-31\"]   \n",
        "2  [\"2014-07-01\", \"2014-11-30\"]   \n",
        "3  [\"2014-12-01\", \"2014-12-31\"]   \n",
        "\n",
        "                                          parameters category  \\\n",
        "0  {\"max_features\": 100, \"vec_time\": [\"2014-07-01...        I   \n",
        "1  {\"max_features\": 100, \"vec_time\": [\"2014-07-01...        I   \n",
        "2                                                 {}        U   \n",
        "3                                                 {}        U   \n",
        "\n",
        "                                     feature_address  \\\n",
        "0  ../features/BOW_2014-07-01_2014-11-30_2014-07-...   \n",
        "1  ../features/BOW_2014-12-01_2014-12-31_2014-07-...   \n",
        "2     ../features/UAVG_2014-07-01_2014-11-30.feature   \n",
        "3     ../features/UAVG_2014-12-01_2014-12-31.feature   \n",
        "\n",
        "                                         description   feature_shape  \n",
        "0  Bag of Words in word count from 2014-07-01 to ...  [1354048, 100]  \n",
        "1  Bag of Words in word count from 2014-12-01 to ...   [272702, 100]  \n",
        "2  User's average forward/comment/like count duri...    [1354048, 3]  \n",
        "3  User's average forward/comment/like count duri...     [272702, 3]  "
       ]
      }
     ],
     "prompt_number": 143
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.test_log"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>test_name</th>\n",
        "      <th>features</th>\n",
        "      <th>fmodel</th>\n",
        "      <th>cmodel</th>\n",
        "      <th>lmodel</th>\n",
        "      <th>dev_f</th>\n",
        "      <th>dev_c</th>\n",
        "      <th>dev_l</th>\n",
        "      <th>precision</th>\n",
        "      <th>model_evaluation</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> BOW_2014-12-01_2014-12-31_2014-07-01_2014-11-3...</td>\n",
        "      <td> [BOW_2014-12-01_2014-12-31_2014-07-01_2014-11-...</td>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> 0.186586</td>\n",
        "      <td> 0.064363</td>\n",
        "      <td> 0.071959</td>\n",
        "      <td> 0.210391</td>\n",
        "      <td> {u'lvs': 0.00174191490741, u'lsos': 348.465020...</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 139,
       "text": [
        "                                           test_name  \\\n",
        "0  BOW_2014-12-01_2014-12-31_2014-07-01_2014-11-3...   \n",
        "\n",
        "                                            features  \\\n",
        "0  [BOW_2014-12-01_2014-12-31_2014-07-01_2014-11-...   \n",
        "\n",
        "                                              fmodel  \\\n",
        "0  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...   \n",
        "\n",
        "                                              cmodel  \\\n",
        "0  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...   \n",
        "\n",
        "                                              lmodel     dev_f     dev_c  \\\n",
        "0  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...  0.186586  0.064363   \n",
        "\n",
        "      dev_l  precision                                   model_evaluation  \n",
        "0  0.071959   0.210391  {u'lvs': 0.00174191490741, u'lsos': 348.465020...  "
       ]
      }
     ],
     "prompt_number": 139
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.train_log"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>model_name</th>\n",
        "      <th>features</th>\n",
        "      <th>model_type</th>\n",
        "      <th>label</th>\n",
        "      <th>model_parameters</th>\n",
        "      <th>evaluation</th>\n",
        "      <th>model_address</th>\n",
        "      <th>train_time</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...</td>\n",
        "      <td> LR</td>\n",
        "      <td> forward_count</td>\n",
        "      <td> {}</td>\n",
        "      <td> {u'sos': 9685.49506353, u'vs': 0.000709021844001}</td>\n",
        "      <td> ../models/BOW_2014-07-01_2014-11-30_2014-07-01...</td>\n",
        "      <td> 8.447040</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...</td>\n",
        "      <td> LR</td>\n",
        "      <td> comment_count</td>\n",
        "      <td> {}</td>\n",
        "      <td> {u'sos': 1417.61594107, u'vs': 0.000346252516327}</td>\n",
        "      <td> ../models/BOW_2014-07-01_2014-11-30_2014-07-01...</td>\n",
        "      <td> 9.041327</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...</td>\n",
        "      <td> LR</td>\n",
        "      <td>    like_count</td>\n",
        "      <td> {}</td>\n",
        "      <td>   {u'sos': 531.54946306, u'vs': 0.00173097462842}</td>\n",
        "      <td> ../models/BOW_2014-07-01_2014-11-30_2014-07-01...</td>\n",
        "      <td> 7.989260</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...</td>\n",
        "      <td> LR</td>\n",
        "      <td> forward_count</td>\n",
        "      <td> {}</td>\n",
        "      <td>   {u'sos': 9482.14453116, u'vs': 0.0216895035912}</td>\n",
        "      <td> ../models/BOW_2014-07-01_2014-11-30_2014-07-01...</td>\n",
        "      <td> 8.574678</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...</td>\n",
        "      <td> LR</td>\n",
        "      <td> comment_count</td>\n",
        "      <td> {}</td>\n",
        "      <td>    {u'sos': 1355.8854957, u'vs': 0.0438764282557}</td>\n",
        "      <td> ../models/BOW_2014-07-01_2014-11-30_2014-07-01...</td>\n",
        "      <td> 8.939181</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5</th>\n",
        "      <td> BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...</td>\n",
        "      <td> [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...</td>\n",
        "      <td> LR</td>\n",
        "      <td>    like_count</td>\n",
        "      <td> {}</td>\n",
        "      <td>     {u'sos': 290.265184023, u'vs': 0.45487153597}</td>\n",
        "      <td> ../models/BOW_2014-07-01_2014-11-30_2014-07-01...</td>\n",
        "      <td> 8.740821</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 140,
       "text": [
        "                                          model_name  \\\n",
        "0  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...   \n",
        "1  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...   \n",
        "2  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...   \n",
        "3  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...   \n",
        "4  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...   \n",
        "5  BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-3...   \n",
        "\n",
        "                                            features model_type  \\\n",
        "0  [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...         LR   \n",
        "1  [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...         LR   \n",
        "2  [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...         LR   \n",
        "3  [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...         LR   \n",
        "4  [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...         LR   \n",
        "5  [BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-...         LR   \n",
        "\n",
        "           label model_parameters  \\\n",
        "0  forward_count               {}   \n",
        "1  comment_count               {}   \n",
        "2     like_count               {}   \n",
        "3  forward_count               {}   \n",
        "4  comment_count               {}   \n",
        "5     like_count               {}   \n",
        "\n",
        "                                          evaluation  \\\n",
        "0  {u'sos': 9685.49506353, u'vs': 0.000709021844001}   \n",
        "1  {u'sos': 1417.61594107, u'vs': 0.000346252516327}   \n",
        "2    {u'sos': 531.54946306, u'vs': 0.00173097462842}   \n",
        "3    {u'sos': 9482.14453116, u'vs': 0.0216895035912}   \n",
        "4     {u'sos': 1355.8854957, u'vs': 0.0438764282557}   \n",
        "5      {u'sos': 290.265184023, u'vs': 0.45487153597}   \n",
        "\n",
        "                                       model_address  train_time  \n",
        "0  ../models/BOW_2014-07-01_2014-11-30_2014-07-01...    8.447040  \n",
        "1  ../models/BOW_2014-07-01_2014-11-30_2014-07-01...    9.041327  \n",
        "2  ../models/BOW_2014-07-01_2014-11-30_2014-07-01...    7.989260  \n",
        "3  ../models/BOW_2014-07-01_2014-11-30_2014-07-01...    8.574678  \n",
        "4  ../models/BOW_2014-07-01_2014-11-30_2014-07-01...    8.939181  \n",
        "5  ../models/BOW_2014-07-01_2014-11-30_2014-07-01...    8.740821  "
       ]
      }
     ],
     "prompt_number": 140
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "features"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 141,
       "text": [
        "['BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-30_100',\n",
        " 'UAVG_2014-07-01_2014-11-30']"
       ]
      }
     ],
     "prompt_number": 141
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.UAVG(['2014-12-01','2014-12-31'])"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>UAVG_forward_count_2014-12-01_2014-12-31</th>\n",
        "      <th>UAVG_comment_count_2014-12-01_2014-12-31</th>\n",
        "      <th>UAVG_like_count_2014-12-01_2014-12-31</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9     </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29    </th>\n",
        "      <td>   0</td>\n",
        "      <td>  5</td>\n",
        "      <td> 1</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272672</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272673</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272674</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272675</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272676</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272677</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272678</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272679</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272680</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272681</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272682</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272683</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272684</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272685</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272686</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272687</th>\n",
        "      <td> 109</td>\n",
        "      <td> 12</td>\n",
        "      <td> 9</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272688</th>\n",
        "      <td> 109</td>\n",
        "      <td> 12</td>\n",
        "      <td> 9</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272689</th>\n",
        "      <td> 109</td>\n",
        "      <td> 12</td>\n",
        "      <td> 9</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272690</th>\n",
        "      <td>   0</td>\n",
        "      <td>  2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272691</th>\n",
        "      <td>   0</td>\n",
        "      <td>  2</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272692</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272693</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272694</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272695</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272696</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272697</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272698</th>\n",
        "      <td>   0</td>\n",
        "      <td>  1</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272699</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272700</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>272701</th>\n",
        "      <td>   0</td>\n",
        "      <td>  0</td>\n",
        "      <td> 0</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>272702 rows \u00d7 3 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 142,
       "text": [
        "        UAVG_forward_count_2014-12-01_2014-12-31  \\\n",
        "0                                              0   \n",
        "1                                              0   \n",
        "2                                              0   \n",
        "3                                              0   \n",
        "4                                              0   \n",
        "5                                              0   \n",
        "6                                              0   \n",
        "7                                              0   \n",
        "8                                              0   \n",
        "9                                              0   \n",
        "10                                             0   \n",
        "11                                             0   \n",
        "12                                             0   \n",
        "13                                             0   \n",
        "14                                             0   \n",
        "15                                             0   \n",
        "16                                             0   \n",
        "17                                             0   \n",
        "18                                             0   \n",
        "19                                             0   \n",
        "20                                             0   \n",
        "21                                             0   \n",
        "22                                             0   \n",
        "23                                             0   \n",
        "24                                             0   \n",
        "25                                             0   \n",
        "26                                             0   \n",
        "27                                             0   \n",
        "28                                             0   \n",
        "29                                             0   \n",
        "...                                          ...   \n",
        "272672                                         0   \n",
        "272673                                         0   \n",
        "272674                                         0   \n",
        "272675                                         0   \n",
        "272676                                         0   \n",
        "272677                                         0   \n",
        "272678                                         0   \n",
        "272679                                         0   \n",
        "272680                                         0   \n",
        "272681                                         0   \n",
        "272682                                         0   \n",
        "272683                                         0   \n",
        "272684                                         0   \n",
        "272685                                         0   \n",
        "272686                                         0   \n",
        "272687                                       109   \n",
        "272688                                       109   \n",
        "272689                                       109   \n",
        "272690                                         0   \n",
        "272691                                         0   \n",
        "272692                                         0   \n",
        "272693                                         0   \n",
        "272694                                         0   \n",
        "272695                                         0   \n",
        "272696                                         0   \n",
        "272697                                         0   \n",
        "272698                                         0   \n",
        "272699                                         0   \n",
        "272700                                         0   \n",
        "272701                                         0   \n",
        "\n",
        "        UAVG_comment_count_2014-12-01_2014-12-31  \\\n",
        "0                                              0   \n",
        "1                                              0   \n",
        "2                                              0   \n",
        "3                                              0   \n",
        "4                                              0   \n",
        "5                                              0   \n",
        "6                                              0   \n",
        "7                                              0   \n",
        "8                                              0   \n",
        "9                                              0   \n",
        "10                                             0   \n",
        "11                                             0   \n",
        "12                                             0   \n",
        "13                                             0   \n",
        "14                                             0   \n",
        "15                                             0   \n",
        "16                                             0   \n",
        "17                                             0   \n",
        "18                                             0   \n",
        "19                                             0   \n",
        "20                                             0   \n",
        "21                                             0   \n",
        "22                                             0   \n",
        "23                                             0   \n",
        "24                                             0   \n",
        "25                                             0   \n",
        "26                                             0   \n",
        "27                                             0   \n",
        "28                                             0   \n",
        "29                                             5   \n",
        "...                                          ...   \n",
        "272672                                         1   \n",
        "272673                                         1   \n",
        "272674                                         1   \n",
        "272675                                         1   \n",
        "272676                                         1   \n",
        "272677                                         1   \n",
        "272678                                         0   \n",
        "272679                                         0   \n",
        "272680                                         0   \n",
        "272681                                         0   \n",
        "272682                                         0   \n",
        "272683                                         0   \n",
        "272684                                         0   \n",
        "272685                                         0   \n",
        "272686                                         0   \n",
        "272687                                        12   \n",
        "272688                                        12   \n",
        "272689                                        12   \n",
        "272690                                         2   \n",
        "272691                                         2   \n",
        "272692                                         0   \n",
        "272693                                         1   \n",
        "272694                                         1   \n",
        "272695                                         1   \n",
        "272696                                         1   \n",
        "272697                                         1   \n",
        "272698                                         1   \n",
        "272699                                         0   \n",
        "272700                                         0   \n",
        "272701                                         0   \n",
        "\n",
        "        UAVG_like_count_2014-12-01_2014-12-31  \n",
        "0                                           0  \n",
        "1                                           0  \n",
        "2                                           0  \n",
        "3                                           0  \n",
        "4                                           0  \n",
        "5                                           0  \n",
        "6                                           0  \n",
        "7                                           0  \n",
        "8                                           0  \n",
        "9                                           0  \n",
        "10                                          0  \n",
        "11                                          0  \n",
        "12                                          0  \n",
        "13                                          0  \n",
        "14                                          0  \n",
        "15                                          0  \n",
        "16                                          0  \n",
        "17                                          0  \n",
        "18                                          0  \n",
        "19                                          0  \n",
        "20                                          0  \n",
        "21                                          0  \n",
        "22                                          0  \n",
        "23                                          0  \n",
        "24                                          0  \n",
        "25                                          0  \n",
        "26                                          0  \n",
        "27                                          0  \n",
        "28                                          0  \n",
        "29                                          1  \n",
        "...                                       ...  \n",
        "272672                                      0  \n",
        "272673                                      0  \n",
        "272674                                      0  \n",
        "272675                                      0  \n",
        "272676                                      0  \n",
        "272677                                      0  \n",
        "272678                                      0  \n",
        "272679                                      0  \n",
        "272680                                      0  \n",
        "272681                                      0  \n",
        "272682                                      0  \n",
        "272683                                      0  \n",
        "272684                                      0  \n",
        "272685                                      0  \n",
        "272686                                      0  \n",
        "272687                                      9  \n",
        "272688                                      9  \n",
        "272689                                      9  \n",
        "272690                                      0  \n",
        "272691                                      0  \n",
        "272692                                      0  \n",
        "272693                                      0  \n",
        "272694                                      0  \n",
        "272695                                      0  \n",
        "272696                                      0  \n",
        "272697                                      0  \n",
        "272698                                      0  \n",
        "272699                                      0  \n",
        "272700                                      0  \n",
        "272701                                      0  \n",
        "\n",
        "[272702 rows x 3 columns]"
       ]
      }
     ],
     "prompt_number": 142
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "features = [fw.features_log.ix[1].feature_name,fw.features_log.ix[3].feature_name]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 144
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fmodel = fw.train_log.model_name[3]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 145
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fmodel"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 146,
       "text": [
        "'BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-30_100_UAVG_2014-07-01_2014-11-30_LR_forward_count'"
       ]
      }
     ],
     "prompt_number": 146
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "cmodel = fw.train_log.model_name[4]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 147
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "cmodel"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 148,
       "text": [
        "'BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-30_100_UAVG_2014-07-01_2014-11-30_LR_comment_count'"
       ]
      }
     ],
     "prompt_number": 148
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "lmodel = fw.train_log.model_name[5]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 149
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "lmodel"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 150,
       "text": [
        "'BOW_2014-07-01_2014-11-30_2014-07-01_2014-11-30_100_UAVG_2014-07-01_2014-11-30_LR_like_count'"
       ]
      }
     ],
     "prompt_number": 150
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import json"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 21
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "data = fw.weibo_predict_data.copy()\n",
      "data['context_clean'] = pd.Series.from_csv('../data/predict_context_clean.csv')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 10
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "data.context_clean[1]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 32,
       "text": [
        "\"['fzuer', 'com']\""
       ]
      }
     ],
     "prompt_number": 32
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "a=Series([[1,2],[3]])"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 33
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "a"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 34,
       "text": [
        "0    [1, 2]\n",
        "1       [3]\n",
        "dtype: object"
       ]
      }
     ],
     "prompt_number": 34
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "fw.weibo_train_data.head()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>uid</th>\n",
        "      <th>mid</th>\n",
        "      <th>time</th>\n",
        "      <th>forward_count</th>\n",
        "      <th>comment_count</th>\n",
        "      <th>like_count</th>\n",
        "      <th>context</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 5fefc2488f99aba5782baa43096b76dc</td>\n",
        "      <td> 2014-11-04</td>\n",
        "      <td> 0</td>\n",
        "      <td> 7</td>\n",
        "      <td> 2</td>\n",
        "      <td> [\u5410]@\u4eac\u4e1c \u7684\u7528\u6237\u4f53\u9a8c\u592a\u5dee\u4e86....\u7b2c\u4e00\u6b21\u5728\u4eac\u4e1c\u8d2d\u7269\uff0c\u4e70\u4e86\u51e0\u767e\u7684\u4e66....\u771f\u662f\u7ecf\u5386\u4e86\u7f51\u8d2d\u7684...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 397d9abe2ebf9ba986fe5ab5a6139e11</td>\n",
        "      <td> 2014-11-04</td>\n",
        "      <td> 0</td>\n",
        "      <td> 3</td>\n",
        "      <td> 0</td>\n",
        "      <td> #\u6211\u7231\u5c0f\u7c73\u624b\u673a#\u56e0\u4e3a\u5c0f\u7c73\u624b\u673a4\u7684\u5c4f\u5e55\u592a\u7ed9\u529b\u4e86\uff0c5\u82f1\u5bf8\u7684\u9ad8\u8272\u5f69\u9971\u548c\u5ea6\u590f\u666e / JDI\u5c4f\u5e55\uff0c19...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> a2ae3959e9aa21a47993506e2609a4ec</td>\n",
        "      <td> 2014-11-08</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td> 0</td>\n",
        "      <td>              [doge][\u55b5\u55b5]\u5929\u732b\u771f\u662f\u725b....\u5356\u5b9e\u9a8c\u8017\u6750\u7684\u90fd\u8dd1\u5929\u732b\u53bb\u5f00\u5e97\u4e86...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> fcc63a086522040a271ba6d1fb604734</td>\n",
        "      <td> 2014-11-09</td>\n",
        "      <td> 0</td>\n",
        "      <td> 6</td>\n",
        "      <td> 0</td>\n",
        "      <td>                                [doge]\u627e\u5de5\u4f5c\u256e(\u256f\u25bd\u2570)\u256d\u2026\u2026</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> 07fc721342df1a4c1992560b582992f8</td>\n",
        "      <td> 6ab0f93ab59cbdaf25f4a023642971a6</td>\n",
        "      <td> 2014-11-11</td>\n",
        "      <td> 0</td>\n",
        "      <td> 5</td>\n",
        "      <td> 1</td>\n",
        "      <td>                                  [doge]\u6210\u529f\u62a2\u4e86\u53f0\u7c734\u7535\u4fe1~</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 8,
       "text": [
        "                                uid                               mid  \\\n",
        "0  07fc721342df1a4c1992560b582992f8  5fefc2488f99aba5782baa43096b76dc   \n",
        "1  07fc721342df1a4c1992560b582992f8  397d9abe2ebf9ba986fe5ab5a6139e11   \n",
        "2  07fc721342df1a4c1992560b582992f8  a2ae3959e9aa21a47993506e2609a4ec   \n",
        "3  07fc721342df1a4c1992560b582992f8  fcc63a086522040a271ba6d1fb604734   \n",
        "4  07fc721342df1a4c1992560b582992f8  6ab0f93ab59cbdaf25f4a023642971a6   \n",
        "\n",
        "         time  forward_count  comment_count  like_count  \\\n",
        "0  2014-11-04              0              7           2   \n",
        "1  2014-11-04              0              3           0   \n",
        "2  2014-11-08              0              0           0   \n",
        "3  2014-11-09              0              6           0   \n",
        "4  2014-11-11              0              5           1   \n",
        "\n",
        "                                             context  \n",
        "0  [\u5410]@\u4eac\u4e1c \u7684\u7528\u6237\u4f53\u9a8c\u592a\u5dee\u4e86....\u7b2c\u4e00\u6b21\u5728\u4eac\u4e1c\u8d2d\u7269\uff0c\u4e70\u4e86\u51e0\u767e\u7684\u4e66....\u771f\u662f\u7ecf\u5386\u4e86\u7f51\u8d2d\u7684...  \n",
        "1  #\u6211\u7231\u5c0f\u7c73\u624b\u673a#\u56e0\u4e3a\u5c0f\u7c73\u624b\u673a4\u7684\u5c4f\u5e55\u592a\u7ed9\u529b\u4e86\uff0c5\u82f1\u5bf8\u7684\u9ad8\u8272\u5f69\u9971\u548c\u5ea6\u590f\u666e / JDI\u5c4f\u5e55\uff0c19...  \n",
        "2               [doge][\u55b5\u55b5]\u5929\u732b\u771f\u662f\u725b....\u5356\u5b9e\u9a8c\u8017\u6750\u7684\u90fd\u8dd1\u5929\u732b\u53bb\u5f00\u5e97\u4e86...  \n",
        "3                                 [doge]\u627e\u5de5\u4f5c\u256e(\u256f\u25bd\u2570)\u256d\u2026\u2026  \n",
        "4                                   [doge]\u6210\u529f\u62a2\u4e86\u53f0\u7c734\u7535\u4fe1~  "
       ]
      }
     ],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}